<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/xhtml;charset=UTF-8"/>
<meta http-equiv="X-UA-Compatible" content="IE=9"/>
<title>Voya Media: SQL Class Reference</title>

<link href="tabs.css" rel="stylesheet" type="text/css"/>
<link href="doxygen.css" rel="stylesheet" type="text/css" />
<link href="navtree.css" rel="stylesheet" type="text/css"/>
<script type="text/javascript" src="jquery.js"></script>
<script type="text/javascript" src="resize.js"></script>
<script type="text/javascript" src="navtree.js"></script>
<script type="text/javascript">
  $(document).ready(initResizable);
</script>


</head>
<body>
<div id="top"><!-- do not remove this div! -->


<div id="titlearea">
<table cellspacing="0" cellpadding="0">
 <tbody>
 <tr style="height: 56px;">
  
  
  <td style="padding-left: 0.5em;">
   <div id="projectname">Voya Media
   &#160;<span id="projectnumber">1.2.255.1212</span>
   </div>
   
  </td>
  
  
  
 </tr>
 </tbody>
</table>
</div>

<!-- Generated by Doxygen 1.8.0 -->
  <div id="navrow1" class="tabs">
    <ul class="tablist">
      <li><a href="index.html"><span>Main&#160;Page</span></a></li>
      <li><a href="namespaces.html"><span>Namespaces</span></a></li>
      <li class="current"><a href="annotated.html"><span>Data&#160;Structures</span></a></li>
      <li><a href="files.html"><span>Files</span></a></li>
    </ul>
  </div>
  <div id="navrow2" class="tabs2">
    <ul class="tablist">
      <li><a href="annotated.html"><span>Data&#160;Structures</span></a></li>
      <li><a href="classes.html"><span>Data&#160;Structure&#160;Index</span></a></li>
      <li><a href="functions.html"><span>Data&#160;Fields</span></a></li>
    </ul>
  </div>
</div>
<div id="side-nav" class="ui-resizable side-nav-resizable">
  <div id="nav-tree">
    <div id="nav-tree-contents">
    </div>
  </div>
  <div id="splitbar" style="-moz-user-select:none;" 
       class="ui-resizable-handle">
  </div>
</div>
<script type="text/javascript">
  initNavTree('a00011.html','');
</script>
<div id="doc-content">
<div class="header">
  <div class="summary">
<a href="#nested-classes">Data Structures</a> &#124;
<a href="#pub-methods">Public Member Functions</a> &#124;
<a href="#properties">Properties</a>  </div>
  <div class="headertitle">
<div class="title">SQL Class Reference</div>  </div>
</div><!--header-->
<div class="contents">

<p>Performs <a class="el" href="a00011.html" title="Performs SQL queries with the Database. Supports inserting, updating, deleting and retrieving data...">SQL</a> queries with the <a class="el" href="a00024.html">Database</a>. Supports inserting, updating, deleting and retrieving data. Takes care of connection handling (opening/closing).  
 <a href="a00011.html#details">More...</a></p>
<table class="memberdecls">
<tr><td colspan="2"><h2><a name="nested-classes"></a>
Data Structures</h2></td></tr>
<tr class="memitem:"><td class="memItemLeft" align="right" valign="top">struct &#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="a00001.html">DatabaseType</a></td></tr>
<tr><td colspan="2"><h2><a name="pub-methods"></a>
Public Member Functions</h2></td></tr>
<tr class="memitem:ae0a810d8b32238b02c5f2beb34ce89b6"><td class="memItemLeft" align="right" valign="top">&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="a00011.html#ae0a810d8b32238b02c5f2beb34ce89b6">SQL</a> (string databaseType=<a class="el" href="a00001.html#a4bdd42eeb51985c062e6b15aa63806fb">DatabaseType.MediaLibrary</a>)</td></tr>
<tr class="memdesc:ae0a810d8b32238b02c5f2beb34ce89b6"><td class="mdescLeft">&#160;</td><td class="mdescRight">Default Constructor.  <a href="#ae0a810d8b32238b02c5f2beb34ce89b6"></a><br/></td></tr>
<tr class="memitem:a814c22b7fa47e475983b5d51f8a35130"><td class="memItemLeft" align="right" valign="top">int&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="a00011.html#a814c22b7fa47e475983b5d51f8a35130">GetDatabaseColumnMaxLength</a> (string tableName, string columnName)</td></tr>
<tr class="memdesc:a814c22b7fa47e475983b5d51f8a35130"><td class="mdescLeft">&#160;</td><td class="mdescRight">Returns the max length of the database table column.  <a href="#a814c22b7fa47e475983b5d51f8a35130"></a><br/></td></tr>
<tr class="memitem:af5063e1eaeecdb73daa8cddce680018a"><td class="memItemLeft" align="right" valign="top">bool&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="a00011.html#af5063e1eaeecdb73daa8cddce680018a">DatabaseColumnExists</a> (string tableName, string columnName)</td></tr>
<tr class="memdesc:af5063e1eaeecdb73daa8cddce680018a"><td class="mdescLeft">&#160;</td><td class="mdescRight">Checks if the database table Column exists in the current database scheme.  <a href="#af5063e1eaeecdb73daa8cddce680018a"></a><br/></td></tr>
<tr class="memitem:a176be089f1f6e93ad949817ec6a910dc"><td class="memItemLeft" align="right" valign="top">bool&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="a00011.html#a176be089f1f6e93ad949817ec6a910dc">DatabaseTableExists</a> (string tableName)</td></tr>
<tr class="memdesc:a176be089f1f6e93ad949817ec6a910dc"><td class="mdescLeft">&#160;</td><td class="mdescRight">Checks if the database Table exists in the current database scheme.  <a href="#a176be089f1f6e93ad949817ec6a910dc"></a><br/></td></tr>
<tr class="memitem:ae721d4e9e35189c7e165bc3ec34e70ea"><td class="memItemLeft" align="right" valign="top">void&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="a00011.html#ae721d4e9e35189c7e165bc3ec34e70ea">DropDatabaseTable</a> (string tableName)</td></tr>
<tr class="memdesc:ae721d4e9e35189c7e165bc3ec34e70ea"><td class="mdescLeft">&#160;</td><td class="mdescRight">Drops/Deletes the <a class="el" href="a00024.html">Database</a> Table.  <a href="#ae721d4e9e35189c7e165bc3ec34e70ea"></a><br/></td></tr>
<tr class="memitem:a705ece1690cc64ce559151e17979109f"><td class="memItemLeft" align="right" valign="top">void&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="a00011.html#a705ece1690cc64ce559151e17979109f">ExecuteSql</a> ()</td></tr>
<tr class="memdesc:a705ece1690cc64ce559151e17979109f"><td class="mdescLeft">&#160;</td><td class="mdescRight">Executes the <a class="el" href="a00011.html" title="Performs SQL queries with the Database. Supports inserting, updating, deleting and retrieving data...">SQL</a> Command.  <a href="#a705ece1690cc64ce559151e17979109f"></a><br/></td></tr>
<tr class="memitem:aea5856de7ce427d271cc71c9e846c547"><td class="memItemLeft" align="right" valign="top">string&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="a00011.html#aea5856de7ce427d271cc71c9e846c547">GetRuntimeExecutingPath</a> ()</td></tr>
<tr class="memdesc:aea5856de7ce427d271cc71c9e846c547"><td class="mdescLeft">&#160;</td><td class="mdescRight">Returns the path from where current code is called from after it has been compiled and deployed. So if the code that calls this method is compiled into "C:\deploy\execute.exe", this method will return "C:\deploy", if it's later moved to "C:\new_dir\execute.exe", it will return "C:\new_dir".  <a href="#aea5856de7ce427d271cc71c9e846c547"></a><br/></td></tr>
<tr class="memitem:a51d603541db4f5550b044994c4c280e0"><td class="memItemLeft" align="right" valign="top">string&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="a00011.html#a51d603541db4f5550b044994c4c280e0">GetCurrentDate</a> ()</td></tr>
<tr class="memitem:a2e6446bb1164e4c3c3dced41b6a066bd"><td class="memItemLeft" align="right" valign="top">DataTable&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="a00011.html#a2e6446bb1164e4c3c3dced41b6a066bd">GetData</a> ()</td></tr>
<tr class="memdesc:a2e6446bb1164e4c3c3dced41b6a066bd"><td class="mdescLeft">&#160;</td><td class="mdescRight">Retrieves data from a database table.  <a href="#a2e6446bb1164e4c3c3dced41b6a066bd"></a><br/></td></tr>
<tr class="memitem:a6a64050f1bad4782c8bbaa3dbbc040c8"><td class="memItemLeft" align="right" valign="top">void&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="a00011.html#a6a64050f1bad4782c8bbaa3dbbc040c8">InitializeDatabases</a> (string databaseType=<a class="el" href="a00001.html#a4bdd42eeb51985c062e6b15aa63806fb">DatabaseType.MediaLibrary</a>)</td></tr>
<tr class="memdesc:a6a64050f1bad4782c8bbaa3dbbc040c8"><td class="mdescLeft">&#160;</td><td class="mdescRight">Initializes and creates all needed databases for this application. This method is run once when the application is opened/started.  <a href="#a6a64050f1bad4782c8bbaa3dbbc040c8"></a><br/></td></tr>
<tr class="memitem:a8549a029a9a289473ca168328aa6d619"><td class="memItemLeft" align="right" valign="top">void&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="a00011.html#a8549a029a9a289473ca168328aa6d619">InsertData</a> ()</td></tr>
<tr class="memdesc:a8549a029a9a289473ca168328aa6d619"><td class="mdescLeft">&#160;</td><td class="mdescRight">Inserts data into a database table.  <a href="#a8549a029a9a289473ca168328aa6d619"></a><br/></td></tr>
<tr class="memitem:acb1dc0d1b304d3a7efd843fb327ef5f3"><td class="memItemLeft" align="right" valign="top">void&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="a00011.html#acb1dc0d1b304d3a7efd843fb327ef5f3">UpdateData</a> (bool whereSearch=false)</td></tr>
<tr class="memdesc:acb1dc0d1b304d3a7efd843fb327ef5f3"><td class="mdescLeft">&#160;</td><td class="mdescRight">Updates existing data in a database table.  <a href="#acb1dc0d1b304d3a7efd843fb327ef5f3"></a><br/></td></tr>
<tr class="memitem:a3552e211fc1fdceceb9845f163eb7bbd"><td class="memItemLeft" align="right" valign="top">void&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="a00011.html#a3552e211fc1fdceceb9845f163eb7bbd">DeleteData</a> (string primaryKeyId)</td></tr>
<tr class="memdesc:a3552e211fc1fdceceb9845f163eb7bbd"><td class="mdescLeft">&#160;</td><td class="mdescRight">Deletes the specified data entry in a database table.  <a href="#a3552e211fc1fdceceb9845f163eb7bbd"></a><br/></td></tr>
<tr><td colspan="2"><h2><a name="properties"></a>
Properties</h2></td></tr>
<tr class="memitem:a02bf5b9c4e9eff9a22147eaf3c6436f2"><td class="memItemLeft" align="right" valign="top">string&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="a00011.html#a02bf5b9c4e9eff9a22147eaf3c6436f2">SqlConnectionString</a><code> [get, set]</code></td></tr>
<tr class="memitem:a577e5b36c81c31dad2c0caa7dda04ca7"><td class="memItemLeft" align="right" valign="top">string&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="a00011.html#a577e5b36c81c31dad2c0caa7dda04ca7">SqlQuery</a><code> [get, set]</code></td></tr>
<tr class="memitem:ab1d85dc45838c672ca90f3be2cd5e9b4"><td class="memItemLeft" align="right" valign="top">Dictionary&lt; string, string &gt;&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="a00011.html#ab1d85dc45838c672ca90f3be2cd5e9b4">SqlCommandParameters</a><code> [get, set]</code></td></tr>
<tr class="memitem:a88e7d214ee4e4dbc16178b575e28618f"><td class="memItemLeft" align="right" valign="top">Dictionary&lt; string, string &gt;&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="a00011.html#a88e7d214ee4e4dbc16178b575e28618f">SqlWhereParameters</a><code> [get, set]</code></td></tr>
<tr class="memitem:abaf38d996df6bba5f2894b63db791bb4"><td class="memItemLeft" align="right" valign="top">string&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="a00011.html#abaf38d996df6bba5f2894b63db791bb4">TableName</a><code> [get, set]</code></td></tr>
</table>
<hr/><a name="details" id="details"></a><h2>Detailed Description</h2>
<div class="textblock"><p>Performs <a class="el" href="a00011.html" title="Performs SQL queries with the Database. Supports inserting, updating, deleting and retrieving data...">SQL</a> queries with the <a class="el" href="a00024.html">Database</a>. Supports inserting, updating, deleting and retrieving data. Takes care of connection handling (opening/closing). </p>

<p>Definition at line <a class="el" href="a00012_source.html#l00021">21</a> of file <a class="el" href="a00012_source.html">Database.cs</a>.</p>
</div><hr/><h2>Constructor &amp; Destructor Documentation</h2>
<a class="anchor" id="ae0a810d8b32238b02c5f2beb34ce89b6"></a>
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname"><a class="el" href="a00011.html">SQL</a> </td>
          <td>(</td>
          <td class="paramtype">string&#160;</td>
          <td class="paramname"><em>databaseType</em> = <code><a class="el" href="a00001.html#a4bdd42eeb51985c062e6b15aa63806fb">DatabaseType.MediaLibrary</a></code></td><td>)</td>
          <td><code> [inline]</code></td>
        </tr>
      </table>
</div>
<div class="memdoc">

<p>Default Constructor. </p>
<dl class="params"><dt><b>Parameters:</b></dt><dd>
  <table class="params">
    <tr><td class="paramname">databaseType</td><td>An optional constant string of the <a class="el" href="a00001.html">Database.SQL.DatabaseType</a> structure.</td></tr>
  </table>
  </dd>
</dl>

<p>Definition at line <a class="el" href="a00012_source.html#l00075">75</a> of file <a class="el" href="a00012_source.html">Database.cs</a>.</p>

</div>
</div>
<hr/><h2>Member Function Documentation</h2>
<a class="anchor" id="af5063e1eaeecdb73daa8cddce680018a"></a>
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">bool <a class="el" href="a00011.html#af5063e1eaeecdb73daa8cddce680018a">DatabaseColumnExists</a> </td>
          <td>(</td>
          <td class="paramtype">string&#160;</td>
          <td class="paramname"><em>tableName</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">string&#160;</td>
          <td class="paramname"><em>columnName</em>&#160;</td>
        </tr>
        <tr>
          <td></td>
          <td>)</td>
          <td></td><td><code> [inline]</code></td>
        </tr>
      </table>
</div>
<div class="memdoc">

<p>Checks if the database table Column exists in the current database scheme. </p>
<dl class="params"><dt><b>Parameters:</b></dt><dd>
  <table class="params">
    <tr><td class="paramname">tableName</td><td>Name of the <a class="el" href="a00024.html">Database</a> Table.</td></tr>
    <tr><td class="paramname">tableName</td><td>Name of the <a class="el" href="a00024.html">Database</a> Column.</td></tr>
  </table>
  </dd>
</dl>
<dl class="section return"><dt>Returns:</dt><dd>A Boolean: True or False.</dd></dl>

<p>Definition at line <a class="el" href="a00012_source.html#l00203">203</a> of file <a class="el" href="a00012_source.html">Database.cs</a>.</p>

</div>
</div>
<a class="anchor" id="a176be089f1f6e93ad949817ec6a910dc"></a>
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">bool <a class="el" href="a00011.html#a176be089f1f6e93ad949817ec6a910dc">DatabaseTableExists</a> </td>
          <td>(</td>
          <td class="paramtype">string&#160;</td>
          <td class="paramname"><em>tableName</em></td><td>)</td>
          <td><code> [inline]</code></td>
        </tr>
      </table>
</div>
<div class="memdoc">

<p>Checks if the database Table exists in the current database scheme. </p>
<dl class="params"><dt><b>Parameters:</b></dt><dd>
  <table class="params">
    <tr><td class="paramname">tableName</td><td>Name of the <a class="el" href="a00024.html">Database</a> Table.</td></tr>
  </table>
  </dd>
</dl>
<dl class="section return"><dt>Returns:</dt><dd>A Boolean: True or False.</dd></dl>

<p>Definition at line <a class="el" href="a00012_source.html#l00260">260</a> of file <a class="el" href="a00012_source.html">Database.cs</a>.</p>

</div>
</div>
<a class="anchor" id="a3552e211fc1fdceceb9845f163eb7bbd"></a>
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">void <a class="el" href="a00011.html#a3552e211fc1fdceceb9845f163eb7bbd">DeleteData</a> </td>
          <td>(</td>
          <td class="paramtype">string&#160;</td>
          <td class="paramname"><em>primaryKeyId</em></td><td>)</td>
          <td><code> [inline]</code></td>
        </tr>
      </table>
</div>
<div class="memdoc">

<p>Deletes the specified data entry in a database table. </p>
<p>Requires the following member properties to be set: TableName String - Defines the <a class="el" href="a00024.html">Database</a> Table Name.</p>
<dl class="params"><dt><b>Parameters:</b></dt><dd>
  <table class="params">
    <tr><td class="paramname">primaryKeyId</td><td>The Primary Key ID of the table record.</td></tr>
  </table>
  </dd>
</dl>

<p>Definition at line <a class="el" href="a00012_source.html#l01331">1331</a> of file <a class="el" href="a00012_source.html">Database.cs</a>.</p>

</div>
</div>
<a class="anchor" id="ae721d4e9e35189c7e165bc3ec34e70ea"></a>
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">void <a class="el" href="a00011.html#ae721d4e9e35189c7e165bc3ec34e70ea">DropDatabaseTable</a> </td>
          <td>(</td>
          <td class="paramtype">string&#160;</td>
          <td class="paramname"><em>tableName</em></td><td>)</td>
          <td><code> [inline]</code></td>
        </tr>
      </table>
</div>
<div class="memdoc">

<p>Drops/Deletes the <a class="el" href="a00024.html">Database</a> Table. </p>
<dl class="params"><dt><b>Parameters:</b></dt><dd>
  <table class="params">
    <tr><td class="paramname">tableName</td><td>Name of the <a class="el" href="a00024.html">Database</a> Table.</td></tr>
  </table>
  </dd>
</dl>

<p>Definition at line <a class="el" href="a00012_source.html#l00316">316</a> of file <a class="el" href="a00012_source.html">Database.cs</a>.</p>

</div>
</div>
<a class="anchor" id="a705ece1690cc64ce559151e17979109f"></a>
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">void <a class="el" href="a00011.html#a705ece1690cc64ce559151e17979109f">ExecuteSql</a> </td>
          <td>(</td>
          <td class="paramname"></td><td>)</td>
          <td><code> [inline]</code></td>
        </tr>
      </table>
</div>
<div class="memdoc">

<p>Executes the <a class="el" href="a00011.html" title="Performs SQL queries with the Database. Supports inserting, updating, deleting and retrieving data...">SQL</a> Command. </p>
<p>Requires the following member properties to be set: SqlQuery String - Defines the <a class="el" href="a00024.html">Database</a> <a class="el" href="a00011.html" title="Performs SQL queries with the Database. Supports inserting, updating, deleting and retrieving data...">SQL</a> Query. </p>

<p>Definition at line <a class="el" href="a00012_source.html#l00331">331</a> of file <a class="el" href="a00012_source.html">Database.cs</a>.</p>

</div>
</div>
<a class="anchor" id="a51d603541db4f5550b044994c4c280e0"></a>
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">string <a class="el" href="a00011.html#a51d603541db4f5550b044994c4c280e0">GetCurrentDate</a> </td>
          <td>(</td>
          <td class="paramname"></td><td>)</td>
          <td><code> [inline]</code></td>
        </tr>
      </table>
</div>
<div class="memdoc">
<dl class="section return"><dt>Returns:</dt><dd></dd></dl>

<p>Definition at line <a class="el" href="a00012_source.html#l00426">426</a> of file <a class="el" href="a00012_source.html">Database.cs</a>.</p>

</div>
</div>
<a class="anchor" id="a2e6446bb1164e4c3c3dced41b6a066bd"></a>
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">DataTable <a class="el" href="a00011.html#a2e6446bb1164e4c3c3dced41b6a066bd">GetData</a> </td>
          <td>(</td>
          <td class="paramname"></td><td>)</td>
          <td><code> [inline]</code></td>
        </tr>
      </table>
</div>
<div class="memdoc">

<p>Retrieves data from a database table. </p>
<p>Requires the following member properties to be set: SqlConnectionString String - Defines the <a class="el" href="a00011.html" title="Performs SQL queries with the Database. Supports inserting, updating, deleting and retrieving data...">SQL</a> <a class="el" href="a00024.html">Database</a> Connection String. SqlQuery String - Defines the <a class="el" href="a00024.html">Database</a> <a class="el" href="a00011.html" title="Performs SQL queries with the Database. Supports inserting, updating, deleting and retrieving data...">SQL</a> Query. TableName String - Defines the <a class="el" href="a00024.html">Database</a> Table Name.</p>
<dl class="section return"><dt>Returns:</dt><dd>The DataSet and all the retrieved data records as a DataTable object.</dd></dl>

<p>Definition at line <a class="el" href="a00012_source.html#l00511">511</a> of file <a class="el" href="a00012_source.html">Database.cs</a>.</p>

</div>
</div>
<a class="anchor" id="a814c22b7fa47e475983b5d51f8a35130"></a>
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">int <a class="el" href="a00011.html#a814c22b7fa47e475983b5d51f8a35130">GetDatabaseColumnMaxLength</a> </td>
          <td>(</td>
          <td class="paramtype">string&#160;</td>
          <td class="paramname"><em>tableName</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">string&#160;</td>
          <td class="paramname"><em>columnName</em>&#160;</td>
        </tr>
        <tr>
          <td></td>
          <td>)</td>
          <td></td><td><code> [inline]</code></td>
        </tr>
      </table>
</div>
<div class="memdoc">

<p>Returns the max length of the database table column. </p>
<dl class="params"><dt><b>Parameters:</b></dt><dd>
  <table class="params">
    <tr><td class="paramname">tableName</td><td>Name of the <a class="el" href="a00024.html">Database</a> Table.</td></tr>
    <tr><td class="paramname">tableName</td><td>Name of the <a class="el" href="a00024.html">Database</a> Column.</td></tr>
  </table>
  </dd>
</dl>
<dl class="section return"><dt>Returns:</dt><dd>An Int: Max length of the column, or -1 if the column was not found or does not have the max char length property.</dd></dl>

<p>Definition at line <a class="el" href="a00012_source.html#l00103">103</a> of file <a class="el" href="a00012_source.html">Database.cs</a>.</p>

</div>
</div>
<a class="anchor" id="aea5856de7ce427d271cc71c9e846c547"></a>
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">string <a class="el" href="a00011.html#aea5856de7ce427d271cc71c9e846c547">GetRuntimeExecutingPath</a> </td>
          <td>(</td>
          <td class="paramname"></td><td>)</td>
          <td><code> [inline]</code></td>
        </tr>
      </table>
</div>
<div class="memdoc">

<p>Returns the path from where current code is called from after it has been compiled and deployed. So if the code that calls this method is compiled into "C:\deploy\execute.exe", this method will return "C:\deploy", if it's later moved to "C:\new_dir\execute.exe", it will return "C:\new_dir". </p>
<dl class="section return"><dt>Returns:</dt><dd>Returns a string representing the Runtime Executing Path.</dd></dl>

<p>Definition at line <a class="el" href="a00012_source.html#l00403">403</a> of file <a class="el" href="a00012_source.html">Database.cs</a>.</p>

</div>
</div>
<a class="anchor" id="a6a64050f1bad4782c8bbaa3dbbc040c8"></a>
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">void <a class="el" href="a00011.html#a6a64050f1bad4782c8bbaa3dbbc040c8">InitializeDatabases</a> </td>
          <td>(</td>
          <td class="paramtype">string&#160;</td>
          <td class="paramname"><em>databaseType</em> = <code><a class="el" href="a00001.html#a4bdd42eeb51985c062e6b15aa63806fb">DatabaseType.MediaLibrary</a></code></td><td>)</td>
          <td><code> [inline]</code></td>
        </tr>
      </table>
</div>
<div class="memdoc">

<p>Initializes and creates all needed databases for this application. This method is run once when the application is opened/started. </p>
<dl class="params"><dt><b>Parameters:</b></dt><dd>
  <table class="params">
    <tr><td class="paramname">databaseType</td><td>An optional constant string of the <a class="el" href="a00001.html">Database.SQL.DatabaseType</a> structure.</td></tr>
  </table>
  </dd>
</dl>

<p>Definition at line <a class="el" href="a00012_source.html#l00587">587</a> of file <a class="el" href="a00012_source.html">Database.cs</a>.</p>

</div>
</div>
<a class="anchor" id="a8549a029a9a289473ca168328aa6d619"></a>
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">void <a class="el" href="a00011.html#a8549a029a9a289473ca168328aa6d619">InsertData</a> </td>
          <td>(</td>
          <td class="paramname"></td><td>)</td>
          <td><code> [inline]</code></td>
        </tr>
      </table>
</div>
<div class="memdoc">

<p>Inserts data into a database table. </p>
<p>Requires the following member properties to be set: SqlCommandParameters Dictionary - Optional String,String Dictionary containing Query Parameters. TableName String - Defines the <a class="el" href="a00024.html">Database</a> Table Name. </p>

<p>Definition at line <a class="el" href="a00012_source.html#l00969">969</a> of file <a class="el" href="a00012_source.html">Database.cs</a>.</p>

</div>
</div>
<a class="anchor" id="acb1dc0d1b304d3a7efd843fb327ef5f3"></a>
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">void <a class="el" href="a00011.html#acb1dc0d1b304d3a7efd843fb327ef5f3">UpdateData</a> </td>
          <td>(</td>
          <td class="paramtype">bool&#160;</td>
          <td class="paramname"><em>whereSearch</em> = <code>false</code></td><td>)</td>
          <td><code> [inline]</code></td>
        </tr>
      </table>
</div>
<div class="memdoc">

<p>Updates existing data in a database table. </p>
<p>Requires the following member properties to be set: TableName String - Defines the <a class="el" href="a00024.html">Database</a> Table Name. SqlCommandParameters Dictionary - Optional Dictionary&lt;String,String&gt; containing Query Parameters. SqlWhereParameters Dictionary - Optional Dictionary&lt;String,String&gt; containing WHERE clause Parameters.</p>
<dl class="params"><dt><b>Parameters:</b></dt><dd>
  <table class="params">
    <tr><td class="paramname">whereSearch</td><td>If true, will make a "key LIKE '%string%'" match instead of a "key='val'" match.</td></tr>
  </table>
  </dd>
</dl>

<p>Definition at line <a class="el" href="a00012_source.html#l01132">1132</a> of file <a class="el" href="a00012_source.html">Database.cs</a>.</p>

</div>
</div>
<hr/><h2>Property Documentation</h2>
<a class="anchor" id="ab1d85dc45838c672ca90f3be2cd5e9b4"></a>
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">Dictionary&lt;string, string&gt; <a class="el" href="a00011.html#ab1d85dc45838c672ca90f3be2cd5e9b4">SqlCommandParameters</a><code> [get, set]</code></td>
        </tr>
      </table>
</div>
<div class="memdoc">

<p>Definition at line <a class="el" href="a00012_source.html#l00047">47</a> of file <a class="el" href="a00012_source.html">Database.cs</a>.</p>

</div>
</div>
<a class="anchor" id="a02bf5b9c4e9eff9a22147eaf3c6436f2"></a>
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">string <a class="el" href="a00011.html#a02bf5b9c4e9eff9a22147eaf3c6436f2">SqlConnectionString</a><code> [get, set]</code></td>
        </tr>
      </table>
</div>
<div class="memdoc">

<p>Definition at line <a class="el" href="a00012_source.html#l00035">35</a> of file <a class="el" href="a00012_source.html">Database.cs</a>.</p>

</div>
</div>
<a class="anchor" id="a577e5b36c81c31dad2c0caa7dda04ca7"></a>
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">string <a class="el" href="a00011.html#a577e5b36c81c31dad2c0caa7dda04ca7">SqlQuery</a><code> [get, set]</code></td>
        </tr>
      </table>
</div>
<div class="memdoc">

<p>Definition at line <a class="el" href="a00012_source.html#l00041">41</a> of file <a class="el" href="a00012_source.html">Database.cs</a>.</p>

</div>
</div>
<a class="anchor" id="a88e7d214ee4e4dbc16178b575e28618f"></a>
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">Dictionary&lt;string, string&gt; <a class="el" href="a00011.html#a88e7d214ee4e4dbc16178b575e28618f">SqlWhereParameters</a><code> [get, set]</code></td>
        </tr>
      </table>
</div>
<div class="memdoc">

<p>Definition at line <a class="el" href="a00012_source.html#l00053">53</a> of file <a class="el" href="a00012_source.html">Database.cs</a>.</p>

</div>
</div>
<a class="anchor" id="abaf38d996df6bba5f2894b63db791bb4"></a>
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">string <a class="el" href="a00011.html#abaf38d996df6bba5f2894b63db791bb4">TableName</a><code> [get, set]</code></td>
        </tr>
      </table>
</div>
<div class="memdoc">

<p>Definition at line <a class="el" href="a00012_source.html#l00059">59</a> of file <a class="el" href="a00012_source.html">Database.cs</a>.</p>

</div>
</div>
<hr/>The documentation for this class was generated from the following file:<ul>
<li><a class="el" href="a00012_source.html">Database.cs</a></li>
</ul>
</div><!-- contents -->
</div>
  <div id="nav-path" class="navpath">
    <ul>
      <li class="navelem"><a class="el" href="a00024.html">Database</a>      </li>
      <li class="navelem"><a class="el" href="a00011.html">SQL</a>      </li>

    <li class="footer">Generated on Thu Jan 10 2013 07:05:20 for Voya Media by
    <a href="http://www.doxygen.org/index.html">
    <img class="footer" src="doxygen.png" alt="doxygen"/></a> 1.8.0 </li>
   </ul>
 </div>


</body>
</html>
